From a6cac61d734919340a68be0199de17b489380a7e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 15:13:14 +0000 Subject: [PATCH] Execute WATCHES.Date v.s. EntryDate check only when necessary --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 0e5c756..2382d97 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -445,7 +445,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () a_type watches.type%TYPE; BEGIN -- Cannot have a watch period before the individual was studied. - IF NEW.entrydate <> OLD.entrydate THEN + IF NEW.entrydate > OLD.entrydate THEN SELECT watches.wid, watches.commid, watches.date, watches.type INTO a_wid , a_commid , a_date , a_type FROM watches -- 2.34.1